﻿CREATE TABLE [dbo].[event] (
    [content_item_id]   BIGINT         NOT NULL,
    [venue_name]        NVARCHAR (255) NULL,
    [venue_map_url]     NVARCHAR (255) NULL,
    [seats]             INT            NULL,
    [has_real_event]    BIT            NULL,
    [has_virtual_event] BIT            NULL,
    [percent_of_slides] INT            NULL,
    [percent_of_demos]  INT            NULL,
    [registration_ends] DATETIME       NULL,
    [banner_image_url]  NVARCHAR (255) NULL,
    [banner_target_url] NVARCHAR (255) NULL,
    [start_date]        SMALLDATETIME  NOT NULL,
    [end_date]          SMALLDATETIME  NOT NULL,
    CONSTRAINT [PK__event__4B97A46849C3F6B7] PRIMARY KEY CLUSTERED ([content_item_id] ASC),
    CONSTRAINT [FKA2FD791696EA32C3] FOREIGN KEY ([content_item_id]) REFERENCES [dbo].[content_item] ([content_item_id])
);

